CREATE VIEW [dbo].[vSoaEventSummary]
AS  
SELECT [Meet_Master].[MEETING] AS [EventId],
       'Public' AS [ParentEntityTypeName],
       'Public Groups' AS [ParentEntityId],
       [Meet_Master].[TITLE] AS [Name],
       CAST([Meet_Master].[DESCRIPTION] AS VARCHAR(6000)) AS [Description],
       [Meet_Master].[MEETING] AS [CategoryId],
       [Meet_Master].[MEETING] AS [CategoryName],
       [Meet_Master].[STATUS] AS [Status]
  FROM [dbo].[Meet_Master]



GO